package cn.wolfcode.crm.query;


import lombok.Getter;
import lombok.Setter;

import java.util.LinkedHashMap;
import java.util.Map;

/**
 * 报表
 */
@Getter
@Setter
public class SalesChartQueryObject extends QueryObject {

    private String groupBy = "saleman.username";

    public static final Map<String, Object> groupType = new LinkedHashMap<>(  );

    static {
        groupType.put( "saleman.username", "销售人员" );
        groupType.put( "agency.name", "保险机构" );
        groupType.put( "product.name", "保险产品" );
        groupType.put( "DATE_FORMAT(s.billdate,'%Y-%m')", "保险日期(月)" );
        groupType.put( "DATE_FORMAT(s.billdate,'%Y-%m-%d')", "保险日期(日)" );
    }


}
